4D Analytics

Conditions Toolbar

Conditional Calculations

  • Example: If({P123}>20,1,0)
  • Syntax If(condition, TruePart, FalsePart).
  • Returns TruePart if condition is met, otherwise returns FalsePart.
  • TruePart & FalsePart can be constants or point idents. For example, If({P123}>20,{P124},{P125})
  • If statements can be nested; for example, If({P123}>20,If({P123}>50,2,1),0)